/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-29 18:01:19
*/


-- ----------------------------
-- Table structure for tb0022
-- ----------------------------
DROP TABLE [dbo].[tb0022]
GO
CREATE TABLE [dbo].[tb0022] (
[CityID] varchar(20) NOT NULL ,
[CityName] nvarchar(100) NULL ,
[Disabled] tinyint NOT NULL DEFAULT ((0)) ,
[CreateDate] datetime NULL ,
[CreateUserID] varchar(20) NULL ,
[LastModifyDate] datetime NULL ,
[LastModifyUserID] varchar(20) NULL 
)


GO

-- ----------------------------
-- Records of tb0022
-- ----------------------------
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'01', N'Hà Nội', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'02', N'Hải Phòng', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'03', N'Hồ Chí Minh', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'04', N'Ñaø Naüng', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'05', N'Hà Tây', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'08', N'Haûi Döông', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'09', N'Höng Yeân', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'11', N'Long An', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'12', N'Tiền Giang', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'13', N'Bến Tre', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-11-16 00:00:36.860', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'14', N'Đồng Tháp', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'15', N'Vĩnh Long', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'16', N'An Giang', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'17', N'Kiên Giang', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'18', N'Cần Thơ', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'19', N'Baïc Lieâu', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'20', N'Caø Mau', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'21', N'Traø Vinh', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'22', N'Soùc Traêng', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'23', N'Baéc Ninh', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'24', N'Baéc Giang', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'25', N'Vónh Phuùc', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'26', N'Phuù Thoï', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'27', N'Ninh Bình', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'28', N'Thanh Hoùa', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'29', N'Ngheä An', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'30', N'Hà Tónh', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'31', N'Quaûng Bình', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'32', N'Quaûng Trò', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'33', N'Hueá', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'34', N'Bình Thuaän', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'35', N'Baø ròa - Vuõng Taøu', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'36', N'Ñoàng Nai', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'37', N'Bình Döông', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'38', N'Bình Phöôùc', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'39', N'Tây Ninh', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'40', N'Quaûng Nam', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'41', N'Bình Ñònh', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'42', N'Khaùnh Hoøa', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'43', N'Quaûng Ngaõi', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'44', N'Phuù Yeân', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'45', N'Ninh Thuaän', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'49', N'Laïng Sôn', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'51', N'Hà Giang', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'54', N'Hoøa Bình', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'55', N'Lai Chaâu', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'57', N'Quaûng Ninh', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'58', N'Laâm Ñoàng', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'59', N'Gia Lai', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'60', N'Ñaéc Laéc', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'61', N'Kon Tum', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO
INSERT INTO [dbo].[tb0022] ([CityID], [CityName], [Disabled], [CreateDate], [CreateUserID], [LastModifyDate], [LastModifyUserID]) VALUES (N'64', N'Ñaéc noâng', N'0', N'2007-10-01 09:29:27.000', N'ADMIN', N'2007-10-01 09:29:27.000', N'ADMIN')
GO
GO

-- ----------------------------
-- Indexes structure for table tb0022
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb0022
-- ----------------------------
ALTER TABLE [dbo].[tb0022] ADD PRIMARY KEY NONCLUSTERED ([CityID])
GO
